Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL ENABLEAUDITING qualifier

Enables auditing for a database.

Syntax

proutil db-name -C enableauditing area Area-Name        [indexarea Index-Area-Name ] [deactivateidx ]

Parameters

db-name

Name of the database to be enabled for auditing.

area Area-Name

Name of the area where the auditing data tables will be located. If Area-Name contains spaces, you must enclose the name in quotation marks.

indexarea Index-Area-Name

Name of the area where the indexes for the auditing data tables will be located. If Index-Area-Name contains spaces, you must enclose the name in quotation marks.

deactivateidx

Deactivate all non-primary indexes for the auditing tables.

Notes

When auditing is first enabled for a database, the meta-schema to support auditing is added to the database, and the event table is populated.
The database must be offline when enabling auditing.
While not required, it is recommended that the auditing tables and indexes be placed in their own area.
Deactivating non-primary indexes is available as an option to improve performance when using database auditing. Deactivated indexes may be activated using PROUTIL IDXBUILD. The non-primary indexes are useful for reporting and should be activated on your audit archive database.
See the "Auditing tables" section for brief descriptions of the meta-schema tables created when auditing is enabled and the indexes which can be deactivated. For detailed information, see OpenEdge Getting Started: Core Business Services .